inherited FConsultaSaldo: TFConsultaSaldo
  Left = 338
  Top = 108
  Width = 593
  Height = 427
  Caption = 'Consulta Saldo'
  Constraints.MaxHeight = 0
  Constraints.MaxWidth = 0
  Constraints.MinHeight = 0
  Constraints.MinWidth = 0
  OldCreateOrder = True
  OnClose = FormClose
  OnCreate = FormCreate
  PixelsPerInch = 96
  TextHeight = 16
  inherited panel2: TPanel
    Width = 585
    inherited BtnExec: TBitBtn
      OnClick = BtnExecClick
    end
  end
  inherited pnBg: TPanel
    Width = 585
    Height = 358
    object Label3: TLabel
      Left = 9
      Top = 13
      Width = 104
      Height = 16
      Caption = 'Empresa - Cliente'
    end
    object Label66: TLabel
      Left = 9
      Top = 57
      Width = 63
      Height = 16
      Caption = 'C'#243'digo(F8)'
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label14: TLabel
      Left = 78
      Top = 58
      Width = 88
      Height = 16
      Caption = 'Ref.Fornecedor'
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label7: TLabel
      Left = 199
      Top = 57
      Width = 85
      Height = 16
      Caption = 'Descri'#231#227'o (F8)'
      Font.Charset = ANSI_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'Arial'
      Font.Style = []
      ParentFont = False
    end
    object Label1: TLabel
      Left = 350
      Top = 338
      Width = 38
      Height = 16
      Alignment = taRightJustify
      Caption = 'Label1'
    end
    object DBLCBLocal: TDBLookupComboBox
      Left = 9
      Top = 27
      Width = 276
      Height = 22
      Ctl3D = False
      KeyField = 'LOC_CODIGO'
      ListField = 'LOC_DESCRICAO'
      ListSource = DSLocal
      ParentCtl3D = False
      TabOrder = 0
      OnKeyDown = DBLCBLocalKeyDown
    end
    object EdCodProdutoMercadoria: TEdit
      Left = 9
      Top = 75
      Width = 65
      Height = 22
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 1
      OnExit = EdCodProdutoMercadoriaExit
      OnKeyDown = EdCodProdutoMercadoriaKeyDown
    end
    object EdRefProdutoMercadoria: TEdit
      Tag = 5
      Left = 78
      Top = 75
      Width = 118
      Height = 22
      Ctl3D = False
      ParentCtl3D = False
      TabOrder = 2
      OnExit = EdRefProdutoMercadoriaExit
    end
    object DBLCBProduto: TDBLookupComboBox
      Left = 199
      Top = 74
      Width = 342
      Height = 22
      Ctl3D = False
      KeyField = 'PROD_CODIGO'
      ListField = 'PROD_DESCRICAOENT'
      ListSource = DSProduto
      ParentCtl3D = False
      TabOrder = 3
      OnExit = DBLCBProdutoExit
      OnKeyDown = DBLCBProdutoKeyDown
    end
    object DBGrid1: TDBGrid
      Left = 8
      Top = 105
      Width = 571
      Height = 226
      DataSource = DSPesquisa
      ReadOnly = True
      TabOrder = 4
      TitleFont.Charset = ANSI_CHARSET
      TitleFont.Color = clWindowText
      TitleFont.Height = -13
      TitleFont.Name = 'Arial'
      TitleFont.Style = []
      Columns = <
        item
          Expanded = False
          FieldName = 'SALDONF_NFNUMERO'
          Title.Alignment = taCenter
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'SALDONF_NFSERIE'
          Title.Alignment = taCenter
          Title.Caption = 'S'#233'rie'
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'SALDONF_CFOP'
          Title.Alignment = taCenter
          Title.Caption = 'CFOP'
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'SALDONF_DATANF'
          Title.Alignment = taCenter
          Title.Caption = 'Data NF'
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'SALDONF_QTD'
          Title.Alignment = taCenter
          Title.Caption = 'Saldo'
          Visible = True
        end
        item
          Alignment = taCenter
          Expanded = False
          FieldName = 'SALDONF_DATA_QTD_ZERO'
          Title.Alignment = taCenter
          Title.Caption = 'Data Zero'
          Visible = True
        end
        item
          Expanded = False
          FieldName = 'SALDONF_VALORUNITARIO'
          Title.Caption = 'Vr. Unit'#225'rio'
          Visible = True
        end>
    end
  end
  object DSLocal: TDataSource
    DataSet = QLocal
    Left = 328
    Top = 48
  end
  object DSProduto: TDataSource
    DataSet = DMGestao.QProdutoEnt
    Left = 440
    Top = 56
  end
  object DSPesquisa: TDataSource
    DataSet = CDSPesquisa
    Left = 352
    Top = 158
  end
  object QPesquisa: TQuery
    DatabaseName = 'base'
    SQL.Strings = (
      'select'
      'saldo_nf_item.saldonf_nfnumero,'
      'saldo_nf_item.saldonf_nfserie,'
      'saldo_nf_item.saldonf_cfop,'
      'saldo_nf_item.saldonf_datanf,'
      'saldo_nf_item.saldonf_qtd,'
      'saldo_nf_item.saldonf_data_qtd_zero,'
      'saldo_nf_item.SALDONF_VALORUNITARIO,'
      'sum(saldo_nf_item.saldonf_qtd) as TOTAL'
      'from saldo_nf_item'
      'group by'
      'saldo_nf_item.saldonf_nfnumero,'
      'saldo_nf_item.saldonf_nfserie,'
      'saldo_nf_item.saldonf_cfop,'
      'saldo_nf_item.saldonf_datanf,'
      'saldo_nf_item.saldonf_qtd,'
      'saldo_nf_item.saldonf_data_qtd_zero,'
      'saldo_nf_item.SALDONF_VALORUNITARIO'
      '')
    Left = 472
    Top = 280
    object QPesquisaSALDONF_NFNUMERO: TIntegerField
      Alignment = taCenter
      DisplayLabel = 'N'#186' NF'
      FieldName = 'SALDONF_NFNUMERO'
    end
    object QPesquisaSALDONF_NFSERIE: TIntegerField
      DisplayLabel = 'S'#233'rie'
      DisplayWidth = 5
      FieldName = 'SALDONF_NFSERIE'
    end
    object QPesquisaSALDONF_CFOP: TStringField
      DisplayLabel = 'CFOP'
      DisplayWidth = 6
      FieldName = 'SALDONF_CFOP'
      Size = 5
    end
    object QPesquisaSALDONF_DATANF: TDateTimeField
      DisplayLabel = 'Data NF'
      DisplayWidth = 12
      FieldName = 'SALDONF_DATANF'
    end
    object QPesquisaSALDONF_QTD: TIntegerField
      DisplayLabel = 'Saldo'
      FieldName = 'SALDONF_QTD'
    end
    object QPesquisaSALDONF_DATA_QTD_ZERO: TDateTimeField
      DisplayLabel = 'Data Zero'
      DisplayWidth = 12
      FieldName = 'SALDONF_DATA_QTD_ZERO'
    end
    object QPesquisaTOTAL: TIntegerField
      FieldName = 'TOTAL'
    end
    object QPesquisaSALDONF_VALORUNITARIO: TFloatField
      FieldName = 'SALDONF_VALORUNITARIO'
    end
  end
  object QLocal: TQuery
    Active = True
    DatabaseName = 'base'
    SQL.Strings = (
      'SELECT * FROM LOCAL'
      'WHERE (EXCLUIDO IS NULL)OR (EXCLUIDO = '#39'N'#39')')
    Left = 320
    Top = 224
  end
  object CDSPesquisa: TClientDataSet
    Aggregates = <>
    Params = <>
    ProviderName = 'DSPPesquisa'
    Left = 96
    Top = 216
    object CDSPesquisaSALDONF_NFNUMERO: TIntegerField
      Alignment = taCenter
      DisplayLabel = 'N'#186' NF'
      FieldName = 'SALDONF_NFNUMERO'
    end
    object CDSPesquisaSALDONF_NFSERIE: TIntegerField
      FieldName = 'SALDONF_NFSERIE'
    end
    object CDSPesquisaSALDONF_CFOP: TStringField
      FieldName = 'SALDONF_CFOP'
      Size = 5
    end
    object CDSPesquisaSALDONF_DATANF: TDateTimeField
      FieldName = 'SALDONF_DATANF'
    end
    object CDSPesquisaSALDONF_QTD: TIntegerField
      FieldName = 'SALDONF_QTD'
    end
    object CDSPesquisaSALDONF_DATA_QTD_ZERO: TDateTimeField
      FieldName = 'SALDONF_DATA_QTD_ZERO'
    end
    object CDSPesquisaTOTAL: TIntegerField
      FieldName = 'TOTAL'
    end
    object CDSPesquisaSALDONF_VALORUNITARIO: TFloatField
      FieldName = 'SALDONF_VALORUNITARIO'
      DisplayFormat = '0,.0000'
    end
  end
  object DSPPesquisa: TDataSetProvider
    DataSet = QPesquisa
    Constraints = True
    Left = 168
    Top = 264
  end
end
